---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
      name:  <unnamed>
       log:  /Users/jesse/Dropbox/Ohio-HallResearch/Code/replication/table_a5.log
  log type:  text
 opened on:  11 Jun 2020, 12:43:29

. 
. use "$path/foreclosures_analysis.dta", clear

. 
. sort fips year

. by fips: gen foreclosure_lead = foreclosure_rate[_n+1]
(2,840 missing values generated)

. compress
  variable year was float now int
  variable adjacency_id was float now int
  variable jud_req was float now byte
  variable sy was float now int
  variable dem_inc was float now byte
  variable period was float now byte
  variable county_p was float now int
  variable popyear was float now byte
  variable poptyear was float now int
  variable safe_dem was float now byte
  variable safe_rep was float now byte
  variable fips was double now long
  variable house_med_inc was double now long
  variable total_records was double now long
  variable foreclosures was double now long
  variable total_votes was double now long
  variable county was str31 now str20
  (562,978 bytes saved)

. 
. bootstrap _b, rep(1e3) seed(94305) cluster(fips) force: reghdfe pres_vs foreclosure_rate foreclosure_inc foreclosure_lead [aw=pop_y], a(fips sy) cluster(fips)
(running reghdfe on estimation sample)

Bootstrap replications (1000)
----+--- 1 ---+--- 2 ---+--- 3 ---+--- 4 ---+--- 5 
..................................................    50
..................................................   100
..................................................   150
..................................................   200
..................................................   250
..................................................   300
..................................................   350
..................................................   400
..................................................   450
..................................................   500
..................................................   550
..................................................   600
..................................................   650
..................................................   700
..................................................   750
..................................................   800
..................................................   850
..................................................   900
..................................................   950
..................................................  1000

HDFE Linear regression                          Number of obs     =      6,275
Absorbing 2 HDFE groups                         Replications      =      1,000
                                                Wald chi2(3)      =      10.30
                                                Prob > chi2       =     0.0162
                                                R-squared         =     0.9898
                                                Adj R-squared     =     0.9835
                                                Root MSE          =     1.8959

                                    (Replications based on 2,247 clusters in fips)
----------------------------------------------------------------------------------
                 |   Observed   Bootstrap                         Normal-based
         pres_vs |      Coef.   Std. Err.      z    P>|z|     [95% Conf. Interval]
-----------------+----------------------------------------------------------------
foreclosure_rate |   .0070031   .0970369     0.07   0.942    -.1831858     .197192
 foreclosure_inc |   .1302801   .0604453     2.16   0.031     .0118096    .2487507
foreclosure_lead |  -.0447028   .0841424    -0.53   0.595    -.2096189    .1202132
----------------------------------------------------------------------------------

Absorbed degrees of freedom:
-------------------------------------------------------------------+
     Absorbed FE |  Num. Coefs.  =   Categories  -   Redundant     | 
-----------------+-------------------------------------------------|
            fips |            0            2247           2247 *   | 
              sy |          146             147              1     | 
-------------------------------------------------------------------+
* = fixed effect nested within cluster; treated as redundant for DoF computation

. local b1 = _b[foreclosure_rate]

. local se1 = _se[foreclosure_rate]

. local bint1 = _b[foreclosure_inc]

. local seint1 = _se[foreclosure_inc]

. local b1_2 = _b[foreclosure_lead]

. local se1_2 = _se[foreclosure_lead]

. local n1 = e(N)

. local nclust1 = e(N_clust)

. 
. bootstrap _b, rep(1e3) seed(94305) cluster(fips) force: reghdfe pres_vs foreclosure_rate foreclosure_inc foreclosure_lead [aw=pop_y], a(fips popyear) cluster(fips)
(running reghdfe on estimation sample)

Bootstrap replications (1000)
----+--- 1 ---+--- 2 ---+--- 3 ---+--- 4 ---+--- 5 
..................................................    50
..................................................   100
..................................................   150
..................................................   200
..................................................   250
..................................................   300
..................................................   350
..................................................   400
..................................................   450
..................................................   500
..................................................   550
..................................................   600
..................................................   650
..................................................   700
..................................................   750
..................................................   800
..................................................   850
..................................................   900
..................................................   950
..................................................  1000

HDFE Linear regression                          Number of obs     =      6,278
Absorbing 2 HDFE groups                         Replications      =      1,000
                                                Wald chi2(3)      =       2.42
                                                Prob > chi2       =     0.4896
                                                R-squared         =     0.9834
                                                Adj R-squared     =     0.9740
                                                Root MSE          =     2.3963

                                    (Replications based on 2,248 clusters in fips)
----------------------------------------------------------------------------------
                 |   Observed   Bootstrap                         Normal-based
         pres_vs |      Coef.   Std. Err.      z    P>|z|     [95% Conf. Interval]
-----------------+----------------------------------------------------------------
foreclosure_rate |   .0664483     .09107     0.73   0.466    -.1120457    .2449422
 foreclosure_inc |  -.0701731   .0574075    -1.22   0.222    -.1826897    .0423435
foreclosure_lead |   -.085199   .0888905    -0.96   0.338    -.2594211    .0890232
----------------------------------------------------------------------------------

Absorbed degrees of freedom:
-------------------------------------------------------------------+
     Absorbed FE |  Num. Coefs.  =   Categories  -   Redundant     | 
-----------------+-------------------------------------------------|
            fips |            0            2248           2248 *   | 
         popyear |           29              30              1     | 
-------------------------------------------------------------------+
* = fixed effect nested within cluster; treated as redundant for DoF computation

. local b2 = _b[foreclosure_rate]

. local se2 = _se[foreclosure_rate]

. local bint2 = _b[foreclosure_inc]

. local seint2 = _se[foreclosure_inc]

. local b2_2 = _b[foreclosure_lead]

. local se2_2 = _se[foreclosure_lead]

. local n2 = e(N)

. local nclust2 = e(N_clust)

. 
. log close
      name:  <unnamed>
       log:  /Users/jesse/Dropbox/Ohio-HallResearch/Code/replication/table_a5.log
  log type:  text
 closed on:  11 Jun 2020, 12:48:29
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
